Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to use the following in "Value Colour" for my expression.
The problem is the colour is not correct, if the answer is > 0 it should show in green however it shows red, but if i filter the data sometimes it shows correctly in green when > 0
The formula I'm using:
=If(
((((Sum({<[TXDATE.autoCalendar.InMTD] = {'1'},[TXDATE.autoCalendar.YearMonth] = {'$(=$(vCurrentMonth))'},[TCODE]={'IN'}>} AMOUNT))
-
(Sum({<[TXDATE.autoCalendar.InMTD] = {'1'},[TXDATE.autoCalendar.YearMonth] = {'$(=$(vCurrentMonth))'},[TCODE]={'CN'}>} AMOUNT)))
-
((Sum({<[TXDATE.autoCalendar.InMTD] = {'1'},[TXDATE.autoCalendar.YearMonth] = {'$(=$(vLYCurrentMonth))'},[TCODE]={'IN'}>} AMOUNT))
-
(Sum({<[TXDATE.autoCalendar.InMTD] = {'1'},[TXDATE.autoCalendar.YearMonth] = {'$(=$(vLYCurrentMonth))'},[TCODE]={'CN'}>} AMOUNT))))
/
((Sum({<[TXDATE.autoCalendar.InMTD] = {'1'},[TXDATE.autoCalendar.YearMonth] = {'$(=$(vLYCurrentMonth))'},[TCODE]={'IN'}>} AMOUNT))
-
(Sum({<[TXDATE.autoCalendar.InMTD] = {'1'},[TXDATE.autoCalendar.YearMonth] = {'$(=$(vLYCurrentMonth))'},[TCODE]={'CN'}>} AMOUNT))))
>'0%','GREEN','RED',)
Or else use num function to make proper format
Can you try by removing '%', try like >'0'
I have tried with
>0
&
>'0'
but no change
First check the expression output format in text object then try to use same in if condition
Or else use num function to make proper format