mamuewue
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Multipass Aggregation Failing
HI Ido_QBeeQ , sorry for bugging you, but I am not figuring it out. Can you have another look. This is what I tried: a) --> Works as a formular but throws an error while calculating it --> b) Doesn't allow me to "save" the formular with the same error as above "Function SUM accepts 1 or 2 parameters". Thanks all...Multipass Aggregation Failing
Hi community, I have a multipass function which isn't doing what I expect from it. In an widget I want to report how many SMS have been send, and if the number is above 5 per "sim_id", the to-be-credited SMS shall be 5. If the number of SMS sent is below 5, the actual amount of SMS shall be credited. I report on the "to-be-credited SMS" field with the following multipass expression: Sum([sim_id], CASE WHEN [Total sms_volume]>5 THEN 5 ELSE [Total sms_volume] END ) When I keep "sim_id" in the rows, the formular does in the total field what it should. The to-be-credited SMS number of 13,399 is correct. (Certainly there are much more rows and pages). The challenge is, i want the "sms_id" row not to appear, and still see the correct 13,399 value. However, when i remove the "sms_id" row, i get the number 5 as result. As per below screenshot. What am I doing wrong? Thanks, MaMueWue
