Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am stuck with a formula to create
The formula is conversion efficiency:-
=sum({<[MARA.Material Type_MTART]={'HALB'}>}[VEKP.Loading volume_NTVOL])/50832*100
the Problem is that if the user selects 3 days, the denominator should get multiplied by 3, the same should happen if the user just selects a single month then the denominator should get multiplied by 30 or 31 depending on the month in the master calendar.
How do i go about doing this
Thanks & regards,
Nadeem
Hi ,
You better create a aditional static column repeated for each row in calendar table.
like 1 as addtional column in script. Afte that you use the sane column in denominator. Just take the sum/count of that column. if you select a month, it will take count for possible numbers.
this should do.
just
Regards,
Chinna
Try: YourExpression / count(distinct date)
- Marcus
Thanks a lot , without you guys it would be just so difficult
Thank you for taking out your time to reply