SUMGT function in Structures

[Former Member]

Hi,

I have a reporting requirement where in i have created a CKF which uses SUMGT function and i want to use this in a structure i have created.

Iam getting an error that i cannot use the SUMGT function in the structures.

Any suggestions on how to do this?

Thanks

Preethi

[former_member189638 · Accepted solution]

Is it a Formula Key Fgure or a Calculated Key Figure?? Because I believe we cannot use SUMGT or SUMCT in a Calculated Key Figure.

Edited by: Rakesh Pattani on Sep 8, 2010 9:41 PM

[Former Member · Accepted solution]

Yes i just realized that you cannot use it in a CKF so i used it in a formula.

I think using formula with SUMGT function in a structure would work.

Anyways thanks for your reply.