topic Re: How count negative differences in App Development

How count negative differences

irmantas — Tue, 30 Nov 2021 16:25:32 GMT

Hi all,

I don't know how write expression to find count negatives for 'Available'-'Consumption' per each Item and total for ProdId

I am looking to find:

PROD1 | 2 (3-5=-2 and 1-2=-1)

PROD2 | 2 (1-2=-1 and 9-10=-1)

stevejoyce — Fri, 12 Nov 2021 15:07:42 GMT

Is it fine to flag in load script/data model?

loadscript:

source_data:
Load
*,
if(Available<Consumption, 1,0) as Fl_NotEnoughAvailable;
load
*

table calc:

count({<Fl_NotEnoughAvailable = {1}>} ItemID)

stevejoyce — Fri, 12 Nov 2021 15:09:38 GMT

The equivalent to do only in front-end would be like...

sum(aggr(if(Available<Consumption,1),[Prod ID], ItemID))

MarcoWedel — Fri, 12 Nov 2021 17:38:01 GMT

-Sum(Consumption>Available)

hope this helps

Marco

irmantas — Mon, 15 Nov 2021 06:43:07 GMT

Thank you Stevejoyce, but I can't do it on loading, because Availability I'm calculating from other tables.

Your equivalent for front-end is not correct and showing "0" at all cases. Do you have any other solution?