Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I have created a varibale and want to insert the same in an expresiion
My expression is ({<HOUR_GROUP-={NR}>}$(vPerClaim)) but It is not working. Kidly correct If I am wrong
Thanks
May be try this:
({<HOUR_GROUP-={'NR'}>}$(vPerClaim))
Not working.
My Problem is if I wite the expression withot a vraivle it workig
eg: sum({<HOUR_GROUP-={NR}>}amount)
What's the definition of your variable?
You can put your expression including the variable in an expression in a straight table and leave the expression label empty, then hover with the mouse over the expression header of the table chart.
It should show your expresssion with the dollar sign expansions expanded. Check if the result is like expected (i.e. variable replaced to your field name).
Thanks
my varible is floows
sum(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV-RF_PROV))-SUM({<CLAIM_NO={'MOTOR SALVAGE LOT'}>}SALVAGE)
If I put this varible in thos way $(vPerClaim) it is working. But when I try couple with set modifier
{<HOUR_GROUP-={NR}>} it does not work
Try what setfan suggested and let us know if you still face the same. Please send us a sample app that defines the problem.
I have tried still the same result
You can´t have a sum inside another sum without an AGGR()
Your variable return a sum() that is inner to a sum()
Usefull reading: Pitfalls of the Aggr function
Thanks
Can you pls rewtite my Variable to help me
You would need to add the set modifier to a set expression in each aggregation function you want it to apply to:
sum({<HOUR_GROUP-={NR}>} rangesum(CL_PROV,+CL_ADJUS,-RE_PROV-RF_PROV))
-SUM({<CLAIM_NO={'MOTOR SALVAGE LOT'}, HOUR_GROUP-={NR}>}SALVAGE)