Hi,
Can some one advise me how to use a if not construction then sum(...) else ? I would like to have some examples. .. as I tries different formulas and it seems it's not working
@algrigore
If there is a requirement to aggregate the selective data then use IF else statement on the DATA itself and then aggregate the new Data line
Data 1 = Full Data Set
Data 2 = IF XXX then Data 1 Else YYY
Target Module = Data 2[SUM: ]
Misbah
Miz Logix
Data 2 should be boolean format or text?
SUM works on Number format only!
I wanted to check if others are facing this specification difference between Grid Card in Additional Insight. When created using a Saved View, the Quick Sum bar feature does not work, but when created using the module directly, the Quick Sum bar works.
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
