Issue with member formula calculation.
Summary
Issue with member formula calculation.Content
HI Experts,
Need you help in understanding a member formula calculation. Getting wrong result,
I have written a formula for member New_York in Demo-> Basic App.
| IF (@ismbr(Jan)) |
Sales = Sales+1000;
ELSE
Sales = 2;
ENDIF;
The result is,
| New_York | ||||
| Actual | Sales | Stereo | Jan | 11001 |
I have entered 1 and ran calc all. The expected result is 1001 but it multiplying 1000*10 and giving result of 11001.
How ever if changed the formula by adding to a test member(Sibling of Sales)
The results are accrurate,
| IF (@ismbr(Jan)) |
Sales = Sales+1000; ELSE Sales = 2; ENDIF;
| New_York | |||||
| Actual | Sales |
0