Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have 2 columns, Fcst Issue and Volumes
Under Fcst Issue column it will be 2+10,1+11,0+12 and Budget
If I select 2+10 in the filter pane, then I should get the value as 2+10 volumes - 1+11 volumes.
Similarly If I select 1+11 in the filter pane, then I should get the value as 1+11 volumes - 0+12 volumes . I am getting only null value in the below formula. Can someone help me?
If([Fcst Issue]='2+10',(Sum({<[Fcst Issue] = {'2+10'}>} [Volumes]) - Sum({<[Fcst Issue] = {'1+11'}>} [Volumes])),
If([Fcst Issue]='1+11',(Sum({<[Fcst Issue] = {'1+11'}>} [Volumes]) - Sum({<[Fcst Issue] = {'0+12'}>} [Volumes])),
If([Fcst Issue]='0+12',(Sum({<[Fcst Issue] = {'0+12'}>} [Volumes]) - Sum({<[Fcst Issue] = {'Budget'}>} [Volumes])),
null())))
The formula is working fine now. Thanks