Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
Please support with the bellow issue:
in Visualization I need to see percentage of data with the condition Aging> than 89 days, and I have the formula, which is not correct working, it`s showing only 1, like I dont have filter [Aging]={'>89'}:
sum({<[Aging]={'>89'}>}Amount.Loc)/Sum([Amount.Loc])
But all data is in Raw data table is correct with aging.
I tried to make the formula in script: sum(If(Aging>89,([Amount.Loc]))) as Aging_delay_Amount,
but again I have an error there.
please advise
How about if you try this with double quotes?
Sum({<[Aging] = {">89"}>} [Amount.Loc])/Sum([Amount.Loc])
How about if you try this with double quotes?
Sum({<[Aging] = {">89"}>} [Amount.Loc])/Sum([Amount.Loc])
Thanks a lot, finaly it works
May be change your script expressi to aflag
sum(If(Aging>89,([Amount.Loc]))) as Aging_delay_Amount,
to
If(Aging>89,1,0)) as Aging_delay_flag
in the chart
Sum({<[Aging_delay_flag] = {1}>} [Amount.Loc])
btw, did you check if your field value a number or a string?
This works good, too thank you