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 have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled