Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a situation where i'm using an if function to determine the Quarterly Accrual Payout and I'm not able to get an aggregation formula to work in order to get the subtotal lines to calculate other than 0.
Below is the formula i'm currently using and getting the 0's on the subtotal lines (picture below).
if(QrtDeadsSavedValue>0 and above([Running Total Acrual])>0,above([Running Total Acrual])*.5,0)
When i change formula to be :
sum(aggr(if(QrtDeadsSavedValue>0 and above([Running Total Acrual])>0,above([Running Total Acrual])*.5,0),EmployeeName,Quarter,FeedyardShortName))
All lines become 0 so i'm missing something, but struggling to figure out what.
Thanks in advance.
Without a data model going to be fairly difficult for anyone to offer any suggestions on this one I believe, a sample app in these situations is generally warranted to ensure responses, so folks can check the data model as well as chart properties and expressions in full. If you have sensitive data, you can use the Scrambling tab in the Settings\Document Properties of the application opened in the Desktop Client to scramble any sensitive fields in the app.
Regards,
Brett