Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to produce a result based on counting the times a certain result is produced within the pivot.
I have the following if statement:
if(if(minstring([_Invoice PO]='Invoice'),Sum( $(vTimePeriod_CurrentYear) [Volume (lbs) (Invoice)])-Sum( $(vTimePeriod_PreviousYear)
[Volume (lbs) (Invoice)]),Sum( $(vTimePeriod_CurrentYear) [Volume (lbs) (PO)])-Sum( $(vTimePeriod_PreviousYear) [Volume (lbs) (PO)]))<0,'Volume ▼'
,if(if(minstring([_Invoice PO]='Invoice'),Sum( $(vTimePeriod_CurrentYear) [Volume (lbs) (Invoice)])-Sum( $(vTimePeriod_PreviousYear) [Volume (lbs) (Invoice)])
,Sum( $(vTimePeriod_CurrentYear) [Volume (lbs) (PO)])-Sum( $(vTimePeriod_PreviousYear) [Volume (lbs) (PO)]))>0,'Volume ▲','Volume ↔'))
How would I write it to count the times Volume ▲ is the result?
There has to be an expert out there that can help me with this?